package com.example.demo.Dao;

import com.example.demo.Model.StuScore;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface StuScoreDao {
    @Select("select * from stuscore")
    public List<StuScore> findAll();
    @Select("select * from stuscore where coID=#{coID}")
    public List<StuScore> findByCoID(String coID);
    @Select("select * from stuscore where stuID=#{stuID}")
    public List<StuScore> findByStuID(String stuID);
    @Select("select * from stuscore where teID=#{teID}")
    public List<StuScore> findByTeID(String teID);
    @Select("select * from stuscore where scyear=#{scyear}")
    public List<StuScore> findByScyear(String scyear);

    @Select("select * from stuscore where stuID=#{stuID} and scyear=#{scyear}")
    public List<StuScore> findBy_stuID_scyear(String stuID,String scyear);

}
